CREATE TABLE [dbo].[typ_zan]
(
[iK_type_vz] [int] NOT NULL IDENTITY(1, 1),
[Cname_typ_vz] [varchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[typ_zan] WITH NOCHECK ADD CONSTRAINT [Checktyp_zanCname_typ_vz] CHECK (([Cname_typ_vz]>' '))
GO
ALTER TABLE [dbo].[typ_zan] ADD CONSTRAINT [PK_typ_zan] PRIMARY KEY CLUSTERED  ([iK_type_vz]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[typ_zan] ADD CONSTRAINT [IX_typ_zan] UNIQUE NONCLUSTERED  ([Cname_typ_vz]) ON [PRIMARY]
GO
